MacWorld 1998 February

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 February / Macworld (1998-02).dmg / Inside Macworld / FileMaker Pro 4 / FM4 Templates w⁄data / Business / Expenses System / Expense Line Items (.txt) < prev

Wrap

FileMaker Pro Database | 1997-09-14 | 124KB | 928 lines

5SC+8PzEy83NJbXp70AqGUhy5n6a XBamEMmp3puYQaIgc+/czYaRm4JWk8BWSxDNvqvIkcw1k3qA4IKnDo0F62gnFAfjAqey8KQ4JJdA UJGADJ/8MdIv9WKfUm7oxatgZOi9PyjFVPXzrB2SAaZiwdst01JRye0tJfZ65rLKcljs4XnXPbK8 WalsXWk4z93Mw8fGf9ysbnDK7KrKhuE9kHGM1+cMxVsXgEFZCKXgBznIyltVQWzk6yZCs2qE3I3d 2GCHCl8TOiAkpMtwhyIWVk6fzkxiJ3i5TwospeUPHrlD9EhcmcnUL9JuWcFhf2W5RLKbxgJido8n WB55T4RoKCm+Qo9PRbXJyJkForiYrhKjdbwFysPnuQm50ilusWBWpefOqJYPRjR38LAXgmBm80ou fzhe3rmSLVdr8J/CmlX1SVivhhz+zIgGCaIYlaJxQx9modrsd/r0Aok4BjJC+A6YB9GMJjge4ItZ HBAM2016AUG95 Pro 3.0 alisA VDEFA HBAM3016AUG95@ HP DeskJet 540 Printer TCP/IP couldn't be initialized (:the manually set TCP/IP address is configured improperly (Jthe TCP/IP address is already in use or an address could not be obtained ( ; This file is created and used by FileMaker Pro for TCP/IP access. ; It should contain one IP address or host name per line. ; Lines starting with a semicolon are ignored. FileMaker Hosts Local Hosts Specify Host...:FileMaker host name is limited to 32 Pro 2.0 - 2.1F! Pro 3.0 - 4.0 AMOUNT 1 AMOUNT 2 AMOUNT 3 AMOUNT 4 AMOUNT 5 AMOUNT 6 AMOUNT 7 CREATED BY DATE CREATED DATE MODIFIED EMPLOYEE ID EXPENSE REPORT ID EXPENSE TYPE e RECORD ID SUMMARY TOTAL WEEK TOTAL AMOUNT 1 TOTAL AMOUNT 2 TOTAL AMOUNT 3 TOTAL AMOUNT 4 TOTAL AMOUNT 5 TOTAL AMOUNT 6 TOTAL AMOUNT 7 TOTAL WEEK Expense Report IDB Date CreatedB Date ModifiedB Amount 1B Amount 2B Amount 3B Amount 4B Amount 5B Pro 2.0 - 2.1F! Pro 3.0 - 4.0 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Description This file contains all the line items on the expense form. By keeping the expense items in a separate file, you have more flexibility than you would if you used a repeating field. How to use this solution Each expense havs an ID number. This number groups all the line items ion the expense form. How to customize this solution Create your own custom reports to see exactly how much is spent in each category. A Form View A List View Expenses by Type Information Report Menu Expenses by Employee A Form ViewB Yesfter Noarter Amount 6B Amount 7B Expense TypeB Total Amount 1B Total Amount 2B Total Amount 3B Total Amount 4B Total Amount 5B Total Amount 6B Total Amount 7B Total WeekB Created ByB InfoB fA Record IDB Employee IDB Summary Total WeekB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close !Enter data for Expense Line Items Expense Report ID Expense Expense Line Items Record ID Expenses File... Week Ending Total Employee Employees File... Expenses by TypeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Weekf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Infop6Click to see more information for an Expense Line Item r Report ID Employee Expense Type Total Week InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Employee Amount Expenses by Type Expense Type Expenses by Type Page ## Your Own Button Reports View As View As Close Report ID Employee Amount Expenses by Type Expense Type Expenses by Type Page ## Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Expense Reports solutionP Info for this Solution bout the Expense Reports solutionP Info for this Solution Your Own ReportB Your Own ReportC Expenses by EmployeeD Expenses by TypeE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Expenses by EmployeeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF 05/09/95Y 10/6/95u Air, Rail, Bus Paul Farrah 10/5/95Y 10/5/95u Taxi, Limousine Paul Farrah 10/5/95Y 10/5/95u Lodging Paul Farrah 10/5/95Y 10/5/95w @ Telephone Paul Farrah 10/5/95Y 10/5/95x Personal Meals 15ul Farrah Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Expense Type Amount Expenses by Employee Employee Expenses by Employee Page ## Your Own Button Reports View As View As Close Report ID Expense Type Amount Expenses by Employee Employee Expenses by Employee Page ## Sort by Expense Type Expenses by Employee Shutdown Script HP DeskJet 540 Printer Helvetica Geneva Times Times New Roman Arial MS Sans Serif 4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Sort by Expense Report ID Sort by Date of End of Week Sort by Last Name Sort by Expense Type Expenses by Type Expenses by Employee Open Script Shutdown Script Sort by Expense Report ID Expenses by Type Sort by Last Name Sort by Date of End of Week Open Script wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw :RPTH FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7RPTH FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 2RPTH FPTHA2HARDDISK:CONSULT:ClarisII:v4:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v4\ (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 AD@D@ AD@D@ 44444 CCCCC 44444 CCCCC $42" @@BA@ bRBBP0 UUUUU JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! (*)(%,3& )%+@6) ",30,)% UUUUUU wwwwww #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0% &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww FMRLA FMRLA Employee ExpensesB Employee Names (LIST VDEFA( Expense Type ListB Project List VDEFA( Helvetica Geneva Times Times New Roman Arial MS Sans Serif :NAME FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 SRPTA emp_exp.fp3 7RPTH FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 2RPTH FPTHA2HARDDISK:CONSULT:ClarisII:v4:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v4\ eRPTH FPTHAeGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses MSPCA NAMEA Employee Expenses RPTHA Employee Expenses bRPTH FPTHAbGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Names MSPCA NAMEA Employee Names RPTHA Employee Names Grendal Employee Names FMP3FMP3 Expenses System bGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Names SCW-InfoMgmt Kevster (7100/66) Grendal Kevin Jundt (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment Grendal Employee Expenses FMP3FMP3 Expenses System eGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses SCW-InfoMgmt Kevster (7100/66) Grendal Kevin Jundt alisA VDEFA WSPC@ alisA VDEFA Paul Farrah 10/5/95Y 10/5/95v 54.30y 60.32 Business Meals 114.62 Paul Farrah 10/5/95Y 10/5/95w 135.60 Entertainment 135.6 Paul Farrah 10/5/95Y 10/5/95v Personal Meals Paul Farrah 10/5/95Y 10/6/95x 4.50y Tolls and Parking Paul Farrah 10/5/95Y 10/6/95x 25.70y 32.48 Personal Meals 58.18 Paul Farrah 10/6/95Y 10/6/95x Lodging Paul Farrah 10/6/95Y 10/6/95x @ Telephone Paul Farrah 10/6/95Y 10/6/95x 129.5y 129.5 Air, Rail, Bus Paul Farrah WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7NAME FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 SRPTA emp_name.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 2NAME FPTHA2HARDDISK:CONSULT:ClarisII:v4:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 SRPTA emp_exp.fp3 WSPCA C:\CONSULT\ClarisII\v4\ eRPTH FPTHAeGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses MSPCA NAMEA Employee Expenses RPTHA Employee Expenses